package cn.bookcycle.requestroom.ConstantData;

/**
 * 一些关于数据库微服务的常量
 *
 * @author liufenglin
 * @date 2018年3月4日
 */
public class DBConstant {
	/** 数据库微服务调用地址 */
	public static final String DB_URI = "http://119.29.242.75:3002/db";
	
	public static final String DATA = "data";
	
	public static final String DB_NAME = "dbName";
	
	public static final String TAB_NAME = "tabName";
	
	public static final String METHOD = "method";
	
	public static final String INSERT = "insert";
	
	public static final String UPDATE = "update";
	
	public static final String FIND = "find";
	
	public static final String SORT = "sort";
	
	public static final String SORT_ORDER = "sortOrder";
	
	public static final String ROOM = "room";
	
	public static final String ROOMS = "rooms";
	
	public static final String date = "date";
	
	/** 代码中的房间ID */
	public static final String ROOM_ID = "roomId";
	
	/** 数据库中的房间ID */
	public static final String ROOM_ID_T = "room_id";
	
	public static final String HOUSE_ID = "houseId";
	
	public static final String LOCK_ID = "lockId";
	
	public static final String EMPTY = "empty";
	
	public static final String STATUS = "status";
	
	public static final String USER = "user";
	
	public static final String SIZE = "size";
	
	/** 代码中的用户ID */
	public static final String USER_ID = "userId";
	
	/** 数据库表中的用户ID */
	public static final String USER_ID_T = "user_id";
	
	public static final String DATE = "date";
	
	public static final String DURATION = "duration";
	
	public static final String START = "start";
	
	public static final String ID = "id";
	
	public static final String FREE_CHANCE = "freeChance";
	
	public static final String FREE_COUNT = "free_count";
	
	public static final String AUTHORIZATION = "authorization";
	
	public static final String UTF8 = "UTF-8";
	
	/** 存放用户信息和用户看房权限信息的数据库名 */
	public static final String USER_ROOM_DB = "user_room";
	
	/** 看房记录表所在的数据库名 */
	public static final String CHECK_ROOM_RECORD_DB = "user_room";
	
	/** 存放锁ID信息所在的数据库 */
	public static final String OPEN_LOCK_ID_DB = "test";
	
	/** 存放锁ID信息所在的表 */
	public static final String OPEN_LOCK_ID_TAB = "houseLock";
	
	/** 看房记录表所在的表名 */
	public static final String CHECK_ROOM_RECORD_TAB = "check_room_record";
	
	/** 存放记录用户已经使用免费看房次数信息的表名 */
	public static final String FREE_CHANCE_TAB = "free_chance";
	
	/** 存放用户与看房权限信息的表名 */
	public static final String CHECK_AUTHORIZATION_TAB = "check_authorization";
	
	/** &符号 */
	public static final String AND_SING = "&";
	
	/** 等于符号 */
	public static final String EQUAL_SIGN = "=";
	
	/** 时间格式中的T符号 */
	public static final String T_SIGN = "T";
	
	/** 时间格式中的冒号 */
	public static final String  COLON_SIGN = ":";
	
	/** 时间格式中的横线符号 */
	public static final String LINE_SIGN = "-";
	
	/** 空字符串 */
	public static final String NULL_SIGN = "";
	
	public static final String  COMMA = ",";
	
	/** 存放房间信息的数据库名 */
	public static final String ROOM_DB = "test";
	
	/** 存放房间信息的表名 */
	public static final String ROOM_TAB = "house";
	
}
